package cn.kgc.mapper;

import cn.kgc.pojo.EmployeeInf;

import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface EmployeeInfMapper {

    int getCount(@Param("name") String name,
                 @Param("cardId") String cardId,
                 @Param("phone") String phone,
                 @Param("deptId") Integer deptId,
                 @Param("jobId") Integer jobId,
                 @Param("sex") Integer sex);

    List<EmployeeInf> getEmployeeInfByPage(@Param("pageNo") Integer pageNo,
                                   @Param("pageSize") Integer pageSize,
                                   @Param("name") String name,
                                   @Param("cardId") String cardId,
                                   @Param("phone") String phone,
                                   @Param("deptId") Integer deptId,
                                   @Param("jobId") Integer jobId,
                                   @Param("sex") Integer sex);

    EmployeeInf getEmployeeInfById(@Param("id") Integer id);

    int updateEmployeeInf(EmployeeInf employeeInf);

    int addEmployeeInf(EmployeeInf employeeInf);

    int delId(Integer id);

    EmployeeInf getEmployeeInfName(@Param("name") String name);
}
